ACCOUNTS
Store Accounts by Invoice
ACCTINVC
INVOICE
0
H
Store Accounts by Name
ACCTNAME
LEFT(UPPER(NAME),8)
Store Accounts by Customer #
ACCTCUST
CUSTNUMB
ACNTPAY
Accounts Payable
DUE_DATE
CATEGORY
SKU Categories
DEPARTMENT+UPPER(LEFT(DESCRIPT,10))
DEPARTMENT+UPPER(LEFT(DESCRIPT,6))
S
Categories By Dept & Number
CATEGNUM
DEPARTMENT+NUMBER
1
CONTROL
Store Information / Settings
CREDITS
Store Acct Paymnt by Customer
CREDCUST
Store Acct Paymnt By Date
CREDDATE
DATE_PAID
Store Credits by Invoice
CREDINV
CTRLSWIT
System Control Switches
SWITCH_NUM
CTRLVAL
Store Control Values
VAL_NUM
CUSTMAIL
Customer Mail List File
CUSTOMER
Customer Master File: By Name
CUSTNAME
UPPER(LNAME+LEFT(FNAME,5))
UPPER(LEFT(LNAME,10)+LEFT(FNAME,5))
A
Customer Master File:By Number
Customer Master File: By Phone
CUSTFONE
RIGHT(SPACE(4)+TRIM(HOME_NUM),4)
LEFT(TRIM(HOME_NUM)+'    ', 4)
DBFINFO
Database Index Driver
DEPTS
Department Numbers
DEPTNUM
DEPT_NUM
Department Names
DEPTNAME
DEPARTMENT
DISCOUNT
Store Discount Choices
EMPLOYEE
Employee Numbers
EMPLOY_NUM
Employee Name List
EMPLNAME
UPPER(LEFT(LNAME,6)+LEFT(FNAME,6))
EMPLSTAT
Employee Status Codes
ESTCUST
Customer Estimates : By Name
ESTNAME
UPPER(LNAME+FNAME)
*UPPER(LNAME+FNAME)
Customer Estimates : By Number
ESTNUMB
*ESTNUMB
ESTIMATE
Estimate Items by Estimate #
ESTNUMBER
*ESTNUMBER
INVENTRY
Inventory File By SKU Number
INVENSKU
SKUCODE
JOURFORM
Journal Template File
JOURNAL
Electronic Journal Invoice #
*INVOICE
LABORS
Canned Labor Descriptions
DEPT+CATEGORY+LEFT(UPPER(DESCRIPT),5)
*DEPT+CATEGORY+LEFT(UPPER(DESCRIPT),5)
Labor Descriptions by Number
LABORNUM
DEPT+CATEGORY+TYPE
*DEPT+CATEGORY+TYPE
LABRATES
Labor Rates per Hour
LAYCUST
Layaway Accounts by Name
LAYCUSTC
UPPER(LEFT(LNAME,8)+LEFT(FNAME,8))
Layaway Accounts by Number
LAYCUSTN
LAYNUMB
Layaway Accounts by Date
LAYCUSTD
DATE_IN
LAYITEM
Layaway Account Items
LAYPAYMT
Layaway Account Payments
Layaway Account Payments Inv.
LAYPYINV
LEDGER
System Account Ledger
DATE
MENUS
Menus by Name
MENU_FORM
MONTHLOG
Log of Journal Files by Month
NOTAX
Non-Taxable Sales Journal
NOTICODE
Customer Notifier Codes
NOTE_CODE
NOTIFIER
Customer Notifier List
DATE_SEND
PACKCODE
Stock Pack Codes
PACK_CODE
Stock Pack Codes by Value
PACKNUMB
PACK_UNITS
PACKDBF
Closing File Maintenance
PAYOUTS
Register Payouts By Date
DATE+PAYREASON
DTOS(DATE)+PAYREASON
Payouts by Reason+Date
PAYREASN
PAYREASON+DATE
PAYREASON+DTOS(DATE)
Payouts Sorted By Vendor
PAYVENDR
STR(VENDOR,5)+DATE+PAYREASON
STR(VENDOR,5)+PAYREASON+DTOS(DATE)
PAYTYPES
Payout Types/Reason Codes
PAYREASON
Payout Reason Names Sort
PAYRENAM
UPPER(LEFT(DESCRIPT,8))
PRINTERS
Printer Driver File
PRODTOTL
Work File for Sales Analysis
RCPHEAD
Receipt Header Information
TYPE+REFERENCE
RCPITEMS
Receipt Items Data
TYPE
RCPMSG
Receipt Trailer Messages
RECVITEM
PO/Receiving Items
REF_NUM
*REF_NUM
RECVLOG
PO/Receiving Log
Received Items Log - By Date
RECPDATE
POST_DATE
*POST_DATE
REPORTS
Report Menu Options
RPTREFNUM
SALETYPE
Sale Types
SETLIST
SKU Sets List
SET_NUMBER
*SET_NUMBER
SKUFILE
SKU Numbers By Category
SKUCATEG
DEPT+CATEGORY+UPPER(LEFT(DESCRIPT,6))
SKU File By SKU Numbers
SKUSETS
SKU Numbers For Sets
TAXCODES
Customer Taxcodes
TAXTYPE+TAXCATEG
TENDDATA
Extended Tendering Info
STR(INVOICE,8)+TENDERNUM
*STR(INVOICE,8)+TENDERNUM
TENDLOG
Transaction Log By Number
TENDNUMB
Transaction Log By Date
TENDDATE
Transaction Log By Customer
TENDCUST
TENDTYPE
Tender Choices File
TENDERNUM
TOTAL
Register Totals By Date
TOTALS
VENDORS
Vendors by Number
VENDNUMB
VENDOR
Vendors by Name
VENDNAME
UPPER(LEFT(NAME,8))
WEEKCAL
Fiscal Week Calendar
END
*END
WORKDATA
Work Station Information
ZIPCODES
City ZIP / Postal Codes
POSTALCODE
SKMATRIX
Sku Item Matrix
UPPER(MATRIXNAME)
*UPPER(MATRIXNAME)